Shareware Grab Bag

home *** CD-ROM | disk | FTP | other *** search

/ Shareware Grab Bag / Shareware Grab Bag.iso / 003 / db3plttr.arc / M401.T < prev next >

Wrap

Text File | 1985-12-26 | 4KB | 242 lines

*4-010 xÇÇÅ rââ┘ Introduction to dBASE III PLUS rÑâ∙∙ rªâ┘ r¿â╤Session 4 r▒â┘ r│â∙∙ r┤â┘ r╢â∙Modify r╝â┘ ö râäτ ├─ ä râàç ╬ râåç ╬ râçç ╬ râêç ╬ râëç å In this session, you will ¼ ræìº■ röìÅModify rÜìç the structure of your database file ræÅº■ röÅÅOrganize r£Åç your file with the SORT command rææº■ röæÅUpdate rÜæç your file with the DELETE, RECALL, & PACK r╞æçcommands rñù┘ Press r¡ù∙──┘ r▒ù┘ to continue or r─ù∙F5 r╞ù┘ to exit q╧ÿÅS,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, *4-014 ràâ┘Modify ▒ rëëÅ ┼ rëèÅ ┼ rëïÅ ┼ rëîÅ ┼ rëìÅ ┼ rëÄÅ ┼ rëÅÅ ┼ rëÉÅ ┼ rëæÅ ┼ q╧ÿÅN,,,,,, a7,P,,,,, *4-015 rÄëÅWhenever you need to modify the structure of your rÄïÅdatabase file by adding or deleting fields, changing rÄìÅfield names or lengths, or rearranging the order of rÄÅÅfields, you do so with the r⌐ÅçMODIFY STRUCTURE r╣ÅÅ command. q╧ÿÅS,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, *4-020 rÄëÅIn the following example, you will make two changes rÄïÅto the structure of your database file. £ rÄìÅ │ rïÅÅ ╞ rÄæÅ Æ râù╕ F9 to review q╧ÿÅS,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, a8,T,4-010,,,&H0043, *4-025 rÄëÅ1. You will insert a new field in the structure of your file. rÄïÅ ¬ rÄîÅThe field you insert will be a logical field. Logical r─îÅfields rÄÄÅallow you to supply róÄçYes rÑÄÅ or r⌐ÄçNo r½ÄÅ information. rüÅÅ ╨ rÄÉÅThe new field will allow you to see at a glance if you've rææÅ Ä rÄÆÅfinished the activities of any given event. q╧ÿÅS,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, a8,T,4-010,,,&H0043, *4-030 rÄëÅ2 rÜëÅchange the width of the r▓ëçWHO r╡ëÅ field from 30 to 25. rÄîÅIt is always good practice to keep field widths to a ë rÄÄÅminimum when r¢ÄÅusing dBASE III PLUS. ë rÉÉÅis allows more space on the disk for greater record ä rÄÆÅstorage. ú q╧ÿÅS,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, a8,T,4-010,,,&H0043, *4-033 xÇÇ╨ rüü╨ Set Up Create ræüé Update rÖü╨ Position Retrieve Organize Modify Tools r┼üé00:00:00 am ræé╨╔ ë═╗ ræâ╨║ rÆâé Append r¢â╨║ ræä╨║ ë─║ ræà╨║ Edit ä ║ ræå╨║ Display ║ ræç╨║ ë─║ ræê╨║ Browse ║ ræë╨║ Replace ║ ræè╨║ ë─║ ræï╨║ Delete ║ ræî╨║ Recall ║ ræì╨║ Pack ä ║ ræÄ╨╚ ë═╝ r¬ò° rüùéASSIST è ║<A:>║TODOLIST Å ║Opt: 1/8 ï ║ å ║ ç q╧ÿéN,,,,,, a7,P,,,,, *4-036 rƒâÅ ò rƒäÅ Press r¿ä M r⌐äÅ to open rƒàÅ ò rƒåÅ the rÑåçModify r½åÅ menu. rƒçÅ ò q╧ÿÅN,,,,,, a7,P,,,,, *4-040 r╣â╕ rºä r⌐ä d╣ä╕││ r┤å╕ à─┘ rüö╕┌ Ä─┐ rüò╕│ râò╕F9 to review rÉò╕│ r╜òÅ Press r┼òçF5 r╟òÅ to exit rüû╕└ Ä─┘ r»ùéRec r╢ùé10 q╧ÿ╨S,,,,,, a7,G,,,,, a8,P,,,,&H6D, a8,C,M002.T,,,&H003F, a8,T,4-040,,,&H0043, *4-043 ræü╨ Update ræé╨ ⌐ ræâ╨ Ä r┤â╨ å ræä╨ Ä ríäÅ æ r┤ä╨ å ræà╨ Ä ríàÅ æ r┤à╨ å ræå╨ ï ríåÅ æ r┤å╨ å ræç╨ Ä r┤ç╨ å ræê╨ ï ræë╨ ï ræè╨ ï ræï╨ ï ræî╨ ï ræì╨ ï ræÄ╨ ï rüö╨ É rüò╨ É rüû╨ É q╧ÿ╨N,,,,,, a7,P,,,,, *4-046 rüü╨ Set Up Create Update Position Retrieve Organize r╢üé Modify r╛ü╨Tools r┼üé00 rƒé╨ ù ╔ Å═╗ r┤â╨ ║ r╖âé Database file r╞â╨║ róäÅPress r⌐ä ──┘ r┤ä╨ ║ Format ê ║ r┤à╨ ║ View è ║ róåÅto select r┤å╨ ║ Query ë ║ r┤ç╨ ║ Report ê ║ rƒêÅ róêçDatabase file r»êÅ à r┤ê╨ ║ Label ë ║ rƒëÅ ò r┤ë╨ ╚ Å═╝ r╢ùé6 q╧ÿ╨S,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, *4-047 r£é╨ ▒ r£â╨ ▒ r£ä╨ ▒ r£à╨ ▒ r£å╨ ▓ r£ç╨ ▒ r£ê╨ ▒ r£ë╨ ▒ r£è╨ ▒ r£ï╨ ▒ r╣ò╨ ÿ rüû╨Command: MODIFY STRUCTURE q╧ÿ╨N,,,,,, a7,C,M402.T,,,, r£å╨ ▓ r£ç╨ ▒ r£ê╨ ▒ r£ë╨ ▒ r£è╨ ▒ r£ï╨ ▒ r╣ò╨